you can use below Query for Interviewer:
SELECT CB_MID,Count(distinct CB_MID) as SurveyCnt,InterviewDate,Interviewer
FROM IMockInterviewCritique
WHERE Interviewer is not null
GROUP BY CB_MID,InterviewDate,Interviewer
you can use below Query for Interviewee:
SELECT CB_MID,Count(distinct CB_MID) as SurveyCnt,InterviewDate,Interviewee
FROM IMockInterviewCritique
WHERE Interviewee is not null
GROUP BY CB_MID,InterviewDate,Interviewee
The link is very informative to get the SQL queries into power bi:
Queries in the Advanced Options 8you can use below Query for Interviewer:
SELECT CB_MID,Count(distinct CB_MID) as SurveyCnt,InterviewDate,Interviewer
FROM IMockInterviewCritique
WHERE Interviewer is not null
GROUP BY CB_MID,InterviewDate,Interviewer
you can use below Query for Interviewee:
SELECT CB_MID,Count(distinct CB_MID) as SurveyCnt,InterviewDate,Interviewee
FROM IMockInterviewCritique
WHERE Interviewee is not null
GROUP BY CB_MID,InterviewDate,Interviewee
The link is very informative to get the SQL queries into power bi: